CREATE  external TABLE jms_ods.yl_meeting_video_upload
(
ID bigint COMMENT '主键ID'
,VIDEO_TIME string COMMENT '视频时长'
,TITLE string COMMENT  '标题'
,DES string COMMENT  '视频描述'
,COMMIT_TIME date COMMENT  '提交时间'
,APP_ACCOUNT string COMMENT 'APP账号'
,APP_ACCOUNT_NAME string COMMENT 'APP账号名称'
,NETWORK_NAME string COMMENT '所属网点名称'
,NETWORK_CODE string COMMENT  '网点CODE'
,NETWORK_ID string COMMENT '网点ID'
,VIDEO_CONTENT string COMMENT  '视频内容'
)PARTITIONED BY (
  `dt` string COMMENT '时间分区(yyyy-MM-dd)')
stored as parquet
LOCATION
'/dw/hive/jms_ods.db/external/yl_meeting_video_upload'
      tblproperties (
      'parquet.column.index.access'= 'true'
);